﻿CREATE TABLE [dbo].[Service_JobDefinition] (
    [ServiceID]       UNIQUEIDENTIFIER NOT NULL,
    [JobDefinitionID] UNIQUEIDENTIFIER NOT NULL,
    CONSTRAINT [PK_Service_JobDefinition] PRIMARY KEY CLUSTERED ([ServiceID] ASC, [JobDefinitionID] ASC),
    CONSTRAINT [FK_Service_JobDefinition_JobDefinition] FOREIGN KEY ([JobDefinitionID]) REFERENCES [dbo].[JobDefinition] ([JobDefinitionID]),
    CONSTRAINT [FK_Service_JobDefinition_Service] FOREIGN KEY ([ServiceID]) REFERENCES [dbo].[Service] ([ServiceID])
);


GO
ALTER TABLE [dbo].[Service_JobDefinition] NOCHECK CONSTRAINT [FK_Service_JobDefinition_JobDefinition];

